Purpose
Keep track of status of krypto portfolio over time, based on transactions combined with current price data.
- Import krypto transaction data from spreadsheet.
- Download latest price data.
- Combine to calculate theoretical profit/loss trends.
- by currency
- overall portfolio
Bitcoin
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
- Get latest price data.
- Combine with cost data.
- Calculate profit and ROI.
Ethereum
Adjusted Cost Base (Avg Cost)
Cardano
Adjusted Cost Base (Avg Cost)
Litecoin
Adjusted Cost Base (Avg Cost)
TOTALS

|
date
|
currency
|
book_val
|
market_val
|
profit
|
roi
|
|
2021-09-19
|
BTC
|
$3,177
|
$4,010
|
833
|
26%
|
|
2021-09-19
|
ETH
|
$5,954
|
$15,343
|
9,388
|
158%
|
|
2021-09-20
|
ADA
|
$2,164
|
$2,040
|
(125)
|
-6%
|
|
2021-09-19
|
LTC
|
$2,305
|
$2,259
|
(46)
|
-2%
|
|
date
|
total_profit
|
total_roi
|
|
2021-09-20
|
$10,050
|
74%
|